USE [HomestayWebDB]
GO
/****** Object:  StoredProcedure [dbo].[Store_New_GetAllNews]    Script Date: 11/26/2012 17:34:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[Store_New_GetAllNews]
AS
BEGIN  
 SELECT NewID,
		Title,
		Header,
		ImageURL,
		TimeCreated,
		CreatedBy  FROM News WHERE IsDeleted='false'
END  